﻿CREATE TABLE [dbo].[Page] (
    [Id]                  UNIQUEIDENTIFIER NOT NULL,
    [Name]                NVARCHAR (MAX)   NOT NULL,
    [Description]         NVARCHAR (MAX)   NULL,
    [ParentId]            UNIQUEIDENTIFIER NULL,
    [PageTemplateId]      UNIQUEIDENTIFIER NOT NULL,
    [Properties]          NVARCHAR (MAX)   NULL,
    [Status]              INT              NOT NULL,
    [Sequence]            INT              DEFAULT ((0)) NOT NULL,
    [Deleted]             BIT              NOT NULL,
    [PublishedProperties] NVARCHAR (MAX)   NULL,
    [DateCreated]         DATETIME         NOT NULL,
    [DatePublished]       DATETIME         NULL,
    [PublishedTemplate]   NVARCHAR (MAX)   NULL,
    [Workflows]           NVARCHAR (MAX)   NULL,
    [PublishedWorkflows]  NVARCHAR (MAX)   NULL,
    [Tags]                NVARCHAR (MAX)   NULL,
    [PublishedCss]        NVARCHAR (MAX)   NULL,
    [PublishedScript]     NVARCHAR (MAX)   NULL,
    [CreatedById]         UNIQUEIDENTIFIER NULL
);





















